package com.maxatime.pojo.data;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

@Data
public class stuInfoDatss {

    //设置Excel - 表头名称 -- @ExcelProperty("学生id")
    //index -- 是表示Excel的列数
//    @ExcelProperty(value = "学生id",index = 0)

    @TableId(value = "id", type = IdType.ID_WORKER_STR)
    @ExcelProperty(value = "学生id",index = 0)
    private String stuId;
    @ExcelProperty(value = "学号",index = 1)
    private Integer stuNum;
    @ExcelProperty(value = "学生姓名",index = 2)
    private String stuName;
    @ExcelProperty(value = "手机号",index = 3)
    private String mobile;
    @ExcelProperty(value = "性别(F:女生;M:男生)",index = 4)
    private String sex;
    @ExcelProperty(value = "年龄",index = 5)
    private Integer age;
    @ExcelProperty(value = "证件类型（C:身份证;X:香港身份证;A:澳门身份证）",index = 6)
    private String idType;
    @ExcelProperty(value = "证件号码",index = 7)
    private String idNum;
//        @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ExcelProperty(value = "出生日期",index = 8)
    private Date birthday;

    @ExcelProperty(value = "删除标志（0:正常;1:删除）",index = 9)
    private Integer deleteFlag;
    @ExcelProperty(value = "籍贯",index = 10)
    private String nativePlace;
    @ExcelProperty(value = "省",index = 11)
    private String provincesId;
    @ExcelProperty(value = "市",index = 12)
    private String citiesId;
    @ExcelProperty(value = "县",index = 13)
    private String areasId;
    @ExcelProperty(value = "详细地址",index = 14)
    private String detailAddr;
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
//    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ExcelProperty(value = "创建时间",index = 15)
    private Date createDate;
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
//    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ExcelProperty(value = "修改时间",index = 16)
    private Date updateDate;
    @ExcelProperty(value = "备注",index = 17)
    private String remark;


}